<?xml version="1.0" encoding="ISO-8859-1" ?>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.util.*,java.io.*,java.sql.*,java.text.*, dbAccess.*"%>
    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content
-Type" content="text/html; charset=ISO-8859-1" />
<title>Doctor Create/Update Process</title>
<link rel="stylesheet" type="text/css" href="css_files/style.css" />
</head>
<body>
 <%
 
 String apptId = request.getParameter("apptId");
 DbAccess access = new DbAccess();
 String query = "update tbl_appointment set IsDeleted = 1 where AppointmentId = " + apptId;
 if (access.ExecuteUpdate(access.connect(), query))
 {
	 out.print("Appointment removed successfully.");
 }
 else
 {
	 out.print("Error ocurred - appointment not removed.");
 }
%>
 <form id="frmback" action="staff2appt.jsp">
 <input type="submit"  name="cmdStaffHome" id="cmdStaffHome" value="Back To Staff Appointments"/>
 </form>
 
</body>
</html>